Page History: SUM Function

Compare Page Revisions

SUM( <value>, <periods>)¶

Computes the sum of the values over the specified number of periods.

Function Parameters
Parameter	Description
<value>	The value field to compute (e.g. `CLOSE`, `HIGH`, `(H+L+C)/3`, etc.)
<periods>	The number of periods to look back.

Example:

SUM(VOLUME, 5)

Example Data
Date	Open	High	Low	Close	Volume	SUM(VOLUME, 5)
06/01/2011	75100	76050	74100	75875	106528
06/02/2011	75750	77000	75450	76650	81891
06/03/2011	76550	76900	75100	75200	80819
06/06/2011	75400	75800	73150	73175	82726
06/07/2011	73200	73775	72925	73675	72927	424891
06/08/2011	73875	76650	73450	76275	113339	431702
06/09/2011	76400	79300	75950	78425	120824	470635
06/10/2011	78500	79975	77725	78575	86989	476805
06/13/2011	78600	79250	77725	78175	78661	472740
06/14/2011	77925	77950	75250	75450	112682	512495
06/15/2011	76025	76225	72550	72575	130420	529576
06/16/2011	72575	72850	69875	70025	125316	534068
06/17/2011	70050	71450	69125	70200	93140	540219
06/20/2011	70450	70775	69550	70150	63702	525260
06/21/2011	70300	71925	70225	70825	71108	483686
06/22/2011	68125	68500	65025	65025	127015	480281
06/23/2011	65000	65300	62000	64675	138220	493185
06/24/2011	65225	65675	62800	62875	78876	478921